ASP.NET Web App Logging using Health Monitoring not working

If you want to see it right away try disabling buffering

<add name="MySqlWebEventProvider" type="System.Web.Management.SqlWebEventProvider" connectionStringName="MySqlConnection" maxEventDetailsLength="1073741823" buffer="true" bufferMode="Logging"/>

change to

<add name="MySqlWebEventProvider" type="System.Web.Management.SqlWebEventProvider" connectionStringName="MySqlConnection" maxEventDetailsLength="1073741823" buffer="false" bufferMode="Logging"/>

This should stop the delay caused by buffering and you should see the rows appear right away.

Plus you may want to decrease your minInterval on the profiles to something quick like "00:00:01" :)

You can read more about buffering here:

http://msdn.microsoft.com/en-us/library/ms178708%28v=vs.80%29.aspx

On a live system it maybe a good idea to leave buffering in place in case you think your SQL server might get overloaded with lots of events firing.

OR

Ive found i can force it save to the log by:

1 : start your project in visual studio 2 : click the button 3 : Stop the project and then start it again 4 : Check in the database you should see an event logged

Try temporarily replacing the SqlWebEventProvider with a TraceWebEventProvider to see if the problem lies in ASP.NET WebEvents or in accessing the SQL database.

The TraceWebEventProvider should avoid permission related problems.

Updated

web.config:

<system.web>
    ...
    <providers>
        <clear/>
            <add name="TraceEventProvider"
        type="System.Web.Management.TraceWebEventProvider, 
          System.Web"
        buffer="false"
        bufferMode=""
        maxEventLength="4096"
        maxSize="4096"
        maxMessagesPerNotification="1"
    />
    </providers>
    ...
    <rules>
        <clear/>
        <add name="All Audits Default" eventName="All Audits" provider="TraceEventProvider" profile="Audit Logs"/>
        <add name="All Errors Default" eventName="All Errors" provider="TraceEventProvider" profile="Error Logs"/>
    </rules>
    ...
</system.web>
...